Class TXLSColumns

DescriptionHierarchyFieldsMethodsProperties

Unit

Declaration

type TXLSColumns = class(TObject)

Description

Methods for manipulating columns. Please note that these methods has no affect on the cell values. They operate only on the columns heading.

Hierarchy

  • TObject
  • TXLSColumns

Overview

Methods

Public constructor Create(AColumns : TXc12Columns; AStyles: TXc12DataStyleSheet);
Public destructor Destroy; override;
Public procedure Clear;
Public function CutHitList(ACol1,ACol2: integer): TXc12Columns;
Public function CopyHitList(ACol1,ACol2: integer): TXc12Columns;
Public procedure OffsetList(AList: TXc12Columns; const AOffset: integer);
Public procedure InsertList(AList: TXc12Columns);
Public function GetColWidth(ACol: integer): integer;
Public function GetColWidthPixels(ACol: integer): integer;
Public procedure SetColWidth(ACol1,ACol2: integer; AValue: integer);
Public procedure DeleteColumns(ACol1,ACol2: integer);
Public procedure ClearColumns(ACol1,ACol2: integer);
Public procedure CopyColumns(ACol1,ACol2,ADestCol: integer);
Public procedure MoveColumns(ACol1,ACol2,ADestCol: integer);
Public procedure InsertColumns(ACol,AColCount: integer);
Public procedure Group(ACol: integer);
Public procedure GroupAll(ALevel: integer);
Public procedure AddIfNone(ACol,ACount: integer);

Properties

Public property OnColWidthChange: TTwoIntegerEvent read FChangeEvent write FChangeEvent;
Public property Items[Index:integer]: TXLSColumn read GetItems;

Description

Methods

Public constructor Create(AColumns : TXc12Columns; AStyles: TXc12DataStyleSheet);
 
Public destructor Destroy; override;
 
Public procedure Clear;
 
Public function CutHitList(ACol1,ACol2: integer): TXc12Columns;

The method creates a TXc12Columns list and copies the the columns between ACol1,ACol2 to the list. The columns between ACol1,ACol2 is then deleted. The object must be destroyed by the caller. This method is mainly for internal use.

Public function CopyHitList(ACol1,ACol2: integer): TXc12Columns;

The method creates a TXc12Columns list and copies the the columns between ACol1,ACol2 to the list. The object must be destroyed by the caller. This methid is mainly for internal use.

Public procedure OffsetList(AList: TXc12Columns; const AOffset: integer);

Offset the columns in AList. For use with lists created with CutHitList or CopyHitList.

Public procedure InsertList(AList: TXc12Columns);

Inserts a column list. For use with lists created with CutHitList or CopyHitList.

Public function GetColWidth(ACol: integer): integer;
 
Public function GetColWidthPixels(ACol: integer): integer;
 
Public procedure SetColWidth(ACol1,ACol2: integer; AValue: integer);
 
Public procedure DeleteColumns(ACol1,ACol2: integer);

Delets all columns between Col1 and Col2. Columns to the right of Col2 will be shifted left.

Public procedure ClearColumns(ACol1,ACol2: integer);

Delets all columns between Col1 and Col2.

Public procedure CopyColumns(ACol1,ACol2,ADestCol: integer);
 
Public procedure MoveColumns(ACol1,ACol2,ADestCol: integer);
 
Public procedure InsertColumns(ACol,AColCount: integer);
 
Public procedure Group(ACol: integer);
 
Public procedure GroupAll(ALevel: integer);
 
Public procedure AddIfNone(ACol,ACount: integer);
 

Properties

Public property OnColWidthChange: TTwoIntegerEvent read FChangeEvent write FChangeEvent;
 
Public property Items[Index:integer]: TXLSColumn read GetItems;
 

Generated by PasDoc 0.12.1 on 2013-03-18 12:36:47